USE [ServerMonitor]
GO
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[SQLServerErrorLog]'))
DROP VIEW [dbo].[SQLServerErrorLog]
GO
USE [ServerMonitor]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[SQLServerErrorLog]
AS
  SELECT [LogTime],[ProcessInfo],[LogText]
  FROM [ServerMonitor].[dbo].[SQLServerLog]
  WHERE IsError = 1

GO


